import xlrd


class ExcelReader:
    def __init__(self):
        self.file_name = "E:/data/swimsuit&underwear/Archive/swimsuit&underwear.xls"

    def read_columns(self, column):
        bk = xlrd.open_workbook(self.file_name)
        sh = bk.sheet_by_name("Sheet1")
        nrows = sh.nrows  # 获取行数
        str_list = []
        for i in range(1, nrows):
            # row_data = sh.row_values(i)
            str_list.append(sh.cell_value(i, column))
        return str_list


if __name__ == '__main__':
    reader = ExcelReader()
    name_list = reader.read_columns(0)
    print(name_list)
